package com.gem.mapper;

import com.gem.domain.JobAPI;
import com.gem.domain.StuCareer;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface CareerMapper {

    //持久层查询所有班级
    @Select("select * from stu_career,student where s_id=sid AND s_status=1 AND career_class_id = #{careerClassId}")
    List<StuCareer> showStuCareer(Integer careerClassId);

    //查询搜索框内容
    List<StuCareer> searchCareer(StuCareer stuCareer);

    //保存修改
    boolean updateStuCareer(StuCareer stuCareer);


    //添加就业信息
    @Insert("insert into stu_career  values(null,#{sid},#{careerStuName},#{careerClassId},0,'无','无','无',0,0,'无','无','无')")
    boolean insertJobAPI(JobAPI jobAP);



}
